from django.db import models

# Create your models here.

#福执工单
class web_db(models.Model):
    datetime = models.CharField(max_length=100,null=True)#报障日期
    datetime_hour = models.CharField(max_length=100,null=True)#报障日期_小时
    datetime_hour_ok = models.CharField(max_length=100,null=True)#报障结束日期_小时
    bzfs = models.CharField(max_length=100,null=True)#保障方式
    name = models.CharField(max_length=100,null=True)#报障人
    doing = models.CharField(max_length=100,null=True)#事件说明
    officeid = models.CharField(max_length=100,null=True)#电话
    sjlx = models.CharField(max_length=100,null=True)#事件类型
    clsc = models.CharField(max_length=100,null=True)#处理时长
    clgcs = models.CharField(max_length=100,null=True)#处理工程师
    qy = models.CharField(max_length=100,null=True)#区域
    llr = models.CharField(max_length=100,null=True)#录入人
    clfs = models.CharField(max_length=100,null=True)#处理方式
    sjjb = models.CharField(max_length=100,null=True)#事件级别
    sjzt = models.CharField(max_length=100,null=True)#事件状态
    clgc = models.CharField(max_length=100,null=True)#处理过程描述 其实就是doding


class ping_test_wangduan_db(models.Model):
    ip_wangduan = models.CharField(primary_key=True,max_length=100,verbose_name='IP')
    ip_out = models.CharField(null=True,max_length=100,verbose_name='需要排除的IP')
    class Meta:
        verbose_name_plural = 'IP管理'


class ping_test_db(models.Model):
    ip = models.CharField(primary_key=True,max_length=100,verbose_name='IP')
    ip_wangguan = models.CharField(max_length=100,verbose_name='网关')
    ip_time = models.DateTimeField(max_length=100,verbose_name='IP最近在线时间')
    ip_tong = models.CharField(max_length=100,verbose_name='IP状态')
    update_ping_out_time = models.IntegerField(verbose_name='已离线时长/小时')
    ip_wangduan = models.CharField(max_length=100,verbose_name='网段')
    class Meta:
        verbose_name_plural = 'IP数据表'



#OSType,ComputerName,CPUModel,RAMSize,DisplayCard,Manufacturer,IPAddress,MACAddress,USB,today,officehome,name
class pc_db(models.Model):
    OSType = models.CharField(max_length=100,verbose_name='系统')
    ComputerName = models.CharField(max_length=100,verbose_name='计算机名字')
    CPUModel = models.CharField(max_length=100,verbose_name='CPU型号')
    RAMSize = models.CharField(max_length=100,verbose_name='内存')
    DisplayCard = models.CharField(max_length=100,verbose_name='显卡型号')
    Manufacturer = models.CharField(max_length=100,verbose_name='主板型号')
    IPAddress = models.CharField(max_length=100,verbose_name='IP地址')
    MACAddress = models.CharField(max_length=100,verbose_name='Mac地址',primary_key=True)
    USB = models.CharField(max_length=100,verbose_name='USB被禁状态')
    today = models.DateTimeField(max_length=100,verbose_name='上传日期')
    officehome = models.CharField(max_length=100,verbose_name='办公室门牌号')
    name = models.CharField(max_length=100,verbose_name='使用人姓名') 
    class Meta:
        verbose_name_plural = '计算机终端'
